<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace='CraftRouteS' xmlns='http://ibatis.apache.org/mapping' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>
  <alias>
    <typeAlias alias='CraftRouteS' assembly='Janus.Mes.POCO.dll' type='Janus.Mes.POCO.CraftRouteS' />
  </alias>
  <resultMaps>
    <resultMap id='CraftRouteSResult' class='CraftRouteS'>
	<result property='Id' column='Id' /> 
	<result property='WorkCCode' column='WorkCCode' /> 
	<result property='ProcCode' column='ProcCode' /> 
	<result property='CraftRCode' column='CraftRCode' /> 
	<result property='Version' column='Version' /> 
	<result property='ProcSeq' column='ProcSeq' /> 
	<result property='ReportMode' column='ReportMode' /> 
	<result property='IsCompCheck' column='IsCompCheck' /> 
	<result property='Loss' column='Loss' /> 
	<result property='EstimatedReadyTime' column='EstimatedReadyTime' /> 
	<result property='EstimatedTime' column='EstimatedTime' /> 
	<result property='MainProgramPath' column='MainProgramPath' /> 
	<result property='ReferenceFile' column='ReferenceFile' /> 
	<result property='KnifeList' column='KnifeList' /> 
	<result property='FixtureList' column='FixtureList' /> 
	<result property='Creator' column='Creator' /> 
	<result property='CreateDate' column='CreateDate' /> 
	<result property='Updater' column='Updater' /> 
	<result property='UpdateDate' column='UpdateDate' /> 
	<result property='IsDelete' column='IsDelete' /> 
	<result property='CreatorCode' column='CreatorCode' /> 
	<result property='UpdaterCode' column='UpdaterCode' /> 
	<result property='OperDept' column='OperDept' /> 
	<result property='Timestamp' column='Timestamp' /> 
		</resultMap>
  </resultMaps>  
  <statements>
  <sql id="UpdaterConditions">  
  <dynamic prepend="SET">
      	<isPropertyAvailable prepend="" property="WorkCCode">
        <isNotEmpty prepend="," property="WorkCCode">
		          [WorkCCode]=#WorkCCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="," property="ProcCode">
		          [ProcCode]=#ProcCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CraftRCode">
        <isNotEmpty prepend="," property="CraftRCode">
		          [CraftRCode]=#CraftRCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Version">
        <isNotEmpty prepend="," property="Version">
		          [Version]=#Version#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ProcSeq">
        <isNotEmpty prepend="," property="ProcSeq">
		          [ProcSeq]=#ProcSeq#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ReportMode">
        <isNotEmpty prepend="," property="ReportMode">
		          [ReportMode]=#ReportMode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsCompCheck">
        <isNotEmpty prepend="," property="IsCompCheck">
		          [IsCompCheck]=#IsCompCheck#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Loss">
        <isNotEmpty prepend="," property="Loss">
		          [Loss]=#Loss#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="EstimatedReadyTime">
        <isNotEmpty prepend="," property="EstimatedReadyTime">
		          [EstimatedReadyTime]=#EstimatedReadyTime#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="EstimatedTime">
        <isNotEmpty prepend="," property="EstimatedTime">
		          [EstimatedTime]=#EstimatedTime#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="MainProgramPath">
        <isNotEmpty prepend="," property="MainProgramPath">
		          [MainProgramPath]=#MainProgramPath#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ReferenceFile">
        <isNotEmpty prepend="," property="ReferenceFile">
		          [ReferenceFile]=#ReferenceFile#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="KnifeList">
        <isNotEmpty prepend="," property="KnifeList">
		          [KnifeList]=#KnifeList#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="FixtureList">
        <isNotEmpty prepend="," property="FixtureList">
		          [FixtureList]=#FixtureList#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">
		          [Creator]=#Creator#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="" property="CreateDate">
				  <isNotEqual prepend="," property="CreateDate" compareValue="1900-01-01">
		          [CreateDate]=#CreateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">
		          [Updater]=#Updater#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="" property="UpdateDate">
				  <isNotEqual prepend="," property="UpdateDate" compareValue="1900-01-01">
		          [UpdateDate]=#UpdateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="" property="IsDelete">
				  <isNotEqual prepend="," property="IsDelete" compareValue="0">
		          [IsDelete]=#IsDelete#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">
		          [CreatorCode]=#CreatorCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">
		          [UpdaterCode]=#UpdaterCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">
		          [OperDept]=#OperDept#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	 </dynamic>
    </sql>
	<sql id="WhereConditions">
	 <dynamic prepend="WHERE">
	 	 <isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="AND" property="Id">
		          [Id]=#Id#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="WorkCCode">
        <isNotEmpty prepend="AND" property="WorkCCode">
		          [WorkCCode]=#WorkCCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="AND" property="ProcCode">
		          [ProcCode]=#ProcCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CraftRCode">
        <isNotEmpty prepend="AND" property="CraftRCode">
		          [CraftRCode]=#CraftRCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Version">
        <isNotEmpty prepend="AND" property="Version">
		          [Version]=#Version#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ProcSeq">
        <isNotEmpty prepend="AND" property="ProcSeq">
		          [ProcSeq]=#ProcSeq#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ReportMode">
        <isNotEmpty prepend="AND" property="ReportMode">
		          [ReportMode]=#ReportMode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsCompCheck">
        <isNotEmpty prepend="AND" property="IsCompCheck">
		          [IsCompCheck]=#IsCompCheck#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Loss">
        <isNotEmpty prepend="AND" property="Loss">
		          [Loss]=#Loss#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="EstimatedReadyTime">
        <isNotEmpty prepend="AND" property="EstimatedReadyTime">
		          [EstimatedReadyTime]=#EstimatedReadyTime#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="EstimatedTime">
        <isNotEmpty prepend="AND" property="EstimatedTime">
		          [EstimatedTime]=#EstimatedTime#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="MainProgramPath">
        <isNotEmpty prepend="AND" property="MainProgramPath">
		          [MainProgramPath]=#MainProgramPath#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ReferenceFile">
        <isNotEmpty prepend="AND" property="ReferenceFile">
		          [ReferenceFile]=#ReferenceFile#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="KnifeList">
        <isNotEmpty prepend="AND" property="KnifeList">
		          [KnifeList]=#KnifeList#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="FixtureList">
        <isNotEmpty prepend="AND" property="FixtureList">
		          [FixtureList]=#FixtureList#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="AND" property="Creator">
		          [Creator]=#Creator#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="" property="CreateDate">
				  <isNotEqual prepend="AND" property="CreateDate" compareValue="1900-01-01">
		          [CreateDate]=#CreateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="AND" property="Updater">
		          [Updater]=#Updater#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="" property="UpdateDate">
				  <isNotEqual prepend="AND" property="UpdateDate" compareValue="1900-01-01">
		          [UpdateDate]=#UpdateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="" property="IsDelete">
				  <isNotEqual prepend="AND" property="IsDelete" compareValue="0">
		          [IsDelete]=#IsDelete#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="AND" property="CreatorCode">
		          [CreatorCode]=#CreatorCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="AND" property="UpdaterCode">
		          [UpdaterCode]=#UpdaterCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="AND" property="OperDept">
		          [OperDept]=#OperDept#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="" property="Timestamp">
				  <isNotEqual prepend="AND" property="Timestamp" compareValue="1900-01-01">
		          [Timestamp]=#Timestamp#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic> 
    </sql>
	<sql id="InsertPublic">
      INSERT INTO CraftRouteS(
	     <dynamic prepend=" ">
       	   <isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="," property="Id">
          [Id]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="WorkCCode">
        <isNotEmpty prepend="," property="WorkCCode">
          [WorkCCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="," property="ProcCode">
          [ProcCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CraftRCode">
        <isNotEmpty prepend="," property="CraftRCode">
          [CraftRCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Version">
        <isNotEmpty prepend="," property="Version">
          [Version]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ProcSeq">
        <isNotEmpty prepend="," property="ProcSeq">
          [ProcSeq]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ReportMode">
        <isNotEmpty prepend="," property="ReportMode">
          [ReportMode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsCompCheck">
        <isNotEmpty prepend="," property="IsCompCheck">
          [IsCompCheck]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Loss">
        <isNotEmpty prepend="," property="Loss">
          [Loss]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="EstimatedReadyTime">
        <isNotEmpty prepend="," property="EstimatedReadyTime">
          [EstimatedReadyTime]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="EstimatedTime">
        <isNotEmpty prepend="," property="EstimatedTime">
          [EstimatedTime]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="MainProgramPath">
        <isNotEmpty prepend="," property="MainProgramPath">
          [MainProgramPath]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ReferenceFile">
        <isNotEmpty prepend="," property="ReferenceFile">
          [ReferenceFile]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="KnifeList">
        <isNotEmpty prepend="," property="KnifeList">
          [KnifeList]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="FixtureList">
        <isNotEmpty prepend="," property="FixtureList">
          [FixtureList]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">
          [Creator]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="," property="CreateDate">
          [CreateDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">
          [Updater]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="," property="UpdateDate">
          [UpdateDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="," property="IsDelete">
          [IsDelete]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">
          [CreatorCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">
          [UpdaterCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">
          [OperDept]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="," property="Timestamp">
          [Timestamp]
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
      VALUES
      (
	   <dynamic prepend=" ">
      	<isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="," property="Id">		
         #Id#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="WorkCCode">
        <isNotEmpty prepend="," property="WorkCCode">		
         #WorkCCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="," property="ProcCode">		
         #ProcCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CraftRCode">
        <isNotEmpty prepend="," property="CraftRCode">		
         #CraftRCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Version">
        <isNotEmpty prepend="," property="Version">		
         #Version#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ProcSeq">
        <isNotEmpty prepend="," property="ProcSeq">		
         #ProcSeq#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ReportMode">
        <isNotEmpty prepend="," property="ReportMode">		
         #ReportMode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsCompCheck">
        <isNotEmpty prepend="," property="IsCompCheck">		
         #IsCompCheck#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Loss">
        <isNotEmpty prepend="," property="Loss">		
         #Loss#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="EstimatedReadyTime">
        <isNotEmpty prepend="," property="EstimatedReadyTime">		
         #EstimatedReadyTime#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="EstimatedTime">
        <isNotEmpty prepend="," property="EstimatedTime">		
         #EstimatedTime#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="MainProgramPath">
        <isNotEmpty prepend="," property="MainProgramPath">		
         #MainProgramPath#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ReferenceFile">
        <isNotEmpty prepend="," property="ReferenceFile">		
         #ReferenceFile#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="KnifeList">
        <isNotEmpty prepend="," property="KnifeList">		
         #KnifeList#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="FixtureList">
        <isNotEmpty prepend="," property="FixtureList">		
         #FixtureList#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">		
         #Creator#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="," property="CreateDate">		
         #CreateDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">		
         #Updater#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="," property="UpdateDate">		
         #UpdateDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="," property="IsDelete">		
         #IsDelete#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">		
         #CreatorCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">		
         #UpdaterCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">		
         #OperDept#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="," property="Timestamp">		
         #Timestamp#		
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
    </sql>
	<!-- Insert statement:新增Mapper-->
    <insert id='Insert' parameterClass='CraftRouteS'>
      <include refid="InsertPublic"/>
    </insert>
    <!--Update statement:修改Mapper-->
    <update id='Update' parameterClass='CraftRouteS'>
      UPDATE [CraftRouteS] 
      <include refid="UpdaterConditions"/>
      WHERE 1=1
	  	  AND Id=#Id#
	      </update>
    <update id='UpdateSetion' parameterClass='hashtable'>
      UPDATE [CraftRouteS] 
      <include refid="UpdaterConditions"/>
      WHERE $conditions$
    </update>
	<update id='Save' parameterClass='CraftRouteS'>
      IF NOT EXISTS(SELECT 1 FROM [CraftRouteS] WHERE 1=1  AND [Id]=#Id# )
      BEGIN
      <include refid="InsertPublic"/>
      END
      ELSE
      BEGIN
      UPDATE CraftRouteS 
      <include refid="UpdaterConditions"/>
      WHERE  1=1
	  	  AND [Id]=#Id#
	        END
    </update>
	<delete id='Delete' parameterClass='hashtable'>
      DELETE FROM [CraftRouteS] WHERE	  
        <![CDATA[  
	 [Id]=#pk0# 
        ]]>
    </delete>
    <delete id='DeleteWhere' parameterClass='string'>
      DELETE FROM [CraftRouteS] WHERE $value$
    </delete>

    <!-- select by key statement:-->
    <select id='FindOne' parameterClass='hashtable' resultClass='CraftRouteS'>
      SELECT * FROM CraftRouteS WHERE      
        <![CDATA[
		[Id]=#pk0# 
        ]]>
    </select>
    <select id='FindAllCondition' parameterClass='string' resultClass='CraftRouteS'>
      SELECT * FROM [CraftRouteS] WHERE $value$
    </select>
    <select id='FindScalar' parameterClass='hashtable' resultClass='CraftRouteS'>
      SELECT * FROM [CraftRouteS] WHERE $conditions$
    </select>
    
    <select id='FindAllCount' parameterClass='string' resultClass='int'>
      SELECT COUNT(1) FROM [CraftRouteS] WHERE $value$
    </select>
    <select id='FindByPage' parameterClass='string' resultClass='CraftRouteS'>
      SELECT * FROM [CraftRouteS] WHERE $value$
    </select>
  </statements>
</sqlMap>
